In [1]:
import sys;sys.path.append("/home/sdementen/Projects/piecash/")
from piecash import open_book
import pandas as pd
In [2]:
# open some book with random data
b = open_book("/home/sdementen/Projects/piecash/gnucash_books/book_schtx.gnucash", open_if_lock=True)
In [3]:
# retrieve the pandas DataFrame with all the Splits
df_splits = b.splits_df()
df_splits
Out[3]:
value quantity transaction.post_date transaction.currency.guid transaction.currency.mnemonic account.fullname account.commodity.guid account.commodity.mnemonic
guid
8086177080d834f762deefbfb6eb6f9b -30 -30 2013-06-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
f5815ea512fef79130578be98df1942e 30 30 2013-06-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Insurance:Auto Insurance e587ae8ea6f67d9b22d343f1323ae3aa EUR
d253b9640ad36f6d7209e80ab6fcc847 -70 -70 2014-01-01 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
3cd5bf1696752091c1daeee469db0393 30 30 2014-01-01 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
67980caca40e0c6ba4434074c5d652cc 40 40 2014-01-01 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
80f458a7fa6868b8b2a74693c0a26e94 -70 -70 2014-02-03 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
c48c260db448da34bba7c25b50d79f9d 30 30 2014-02-03 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
f0b581a807e0fd56c56675a3bf2e5d35 40 40 2014-02-03 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
fd3cf31862d8b819788d5d1b199b3884 40 40 2014-03-03 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
bf8da2e7b105d900727b470bc09f8fc7 -70 -70 2014-03-03 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
bc9d1070f8a5d8eb04c1801f8547090f 30 30 2014-03-03 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
d503ccc7ee2c0a665444cb10bd6be932 -70 -70 2014-04-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
c33a9288e28a7b9b172c07905c3da3ee 30 30 2014-04-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
532f04ee3ffdb9dbe35e16db7e2ac01d 40 40 2014-04-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
54ef011e599b2d47526e5c687c1e1ee4 30 30 2014-05-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
7c672e1433d08f860930bd7b84bd47b7 -70 -70 2014-05-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
d0ecb688d86bae42720c4069f8391089 40 40 2014-05-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
4765999a3bf47ee134d232f8db7849d3 -30 -30 2014-05-30 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
222d2905893a557dc05a2e719da6be48 30 30 2014-05-30 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Insurance:Auto Insurance e587ae8ea6f67d9b22d343f1323ae3aa EUR
894bf776faa4c91bb0ef7fc4f4a8a061 30 30 2014-06-02 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
db1536fc38811bb9e17430da51a27cd4 40 40 2014-06-02 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
0b6465dec33d9a423b59277a09d3d38c -70 -70 2014-06-02 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
8a20778818902facf90f423c3ea5c840 40 40 2014-07-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
b797a9218fa2faf4ad0086a907aa8116 -70 -70 2014-07-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
bed8cb43b338907df9d1f77d6573d967 30 30 2014-07-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
d962d8a7587f6da4c0399eeeccbc3a09 -70 -70 2014-08-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
8be862f84e2a195a3a56bb2373f62ee4 30 30 2014-08-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
6947ebc9e25712691db063e93bf05511 40 40 2014-08-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
99c1c28767b8857ba682f28a3fe845e2 -70 -70 2014-09-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
f4532a75cac9c411f22ee6910140b9b4 30 30 2014-09-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
... ... ... ... ... ... ... ... ...
36299708b4f436a4140a029a568621d3 30 30 2015-03-02 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
1e3f089c1a5de84a425a744477238dfd 40 40 2015-03-02 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
66d618671346f58f337aa95147f3d513 40 40 2015-04-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
7f575c7bfa7f7a44ed3d5e6fade3b8bc 30 30 2015-04-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
babbf1108ea7494dda52c7541588c6d0 -70 -70 2015-04-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
0cf3339f25fb08b3a16e695ef1b14298 -70 -70 2015-05-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
57bc46394d2c55b70cde61d3af85048f 30 30 2015-05-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
9ab85cdbe164b9ae74dcd7eb120de05d 40 40 2015-05-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
e58fb24764c0d5f49702b5a2613ff355 -70 -70 2015-06-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
8e8050a44fbe1904891b43f7d93fc1e4 30 30 2015-06-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
e5217317ea17b6f0d693d027957347eb 40 40 2015-06-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
16e25b691c483ab5dc2d44cb9986ed96 -30 -30 2015-06-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
a0f91b5168cae71efaa04a92e6fd690e 30 30 2015-06-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Insurance:Auto Insurance e587ae8ea6f67d9b22d343f1323ae3aa EUR
1f5bb2902dbfd0205696a19208990b7b 30 30 2015-07-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
d52ec5ccc6f2e4b41d73f2be6014f797 -70 -70 2015-07-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
65907a487e0f6ce51427d4087b67436e 40 40 2015-07-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
244f35a987121dbe83f0c145062cd3ac -70 -70 2015-08-03 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
21f09995e9b854f76f032d7ae1622fe0 30 30 2015-08-03 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
746732f3c3a9c516018391cc2b2d3d50 40 40 2015-08-03 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
fe31789a46477fe4b21cbe4c7540917a -70 -70 2015-09-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
dad0f92ffb153419def59f7347e85ad6 30 30 2015-09-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
6c8605e2272521b155c757ce8188b3d3 40 40 2015-09-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
7d0cfeee32ff9b220ccb4d4073e15215 -70 -70 2015-10-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
83b1f1e2e572bf151e74b86c05e16ede 30 30 2015-10-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
587ca3a65b1d9afa1b738bdd7d1fb9bb 40 40 2015-10-01 00:00:00+02:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
bdbaec8af86ad4fa71a638c9073da910 -70 -70 2015-11-02 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
4f91d130dada6f7b4b5d18f565596c87 30 30 2015-11-02 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Electric e587ae8ea6f67d9b22d343f1323ae3aa EUR
6ee21b2092bec6840c1aff8fe6e46bbe 40 40 2015-11-02 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Expenses:Utilities:Gas e587ae8ea6f67d9b22d343f1323ae3aa EUR
f4a182e49b477430311093115095f062 100 100 2015-11-18 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:Checking Account e587ae8ea6f67d9b22d343f1323ae3aa EUR
e83ac1dc4b93f21de5b47866798088e0 -100 -106.32 2015-11-18 00:00:00+01:00 e587ae8ea6f67d9b22d343f1323ae3aa EUR Assets:Current Assets:us account f5a697eafdccb7491e669594cefe0c14 USD

81 rows × 8 columns

In [4]:
# calculate the running balance for each account
df_balance = df_splits\
        .groupby(["account.fullname", "transaction.post_date"])[["value", "quantity"]]\
        .sum()\
        .groupby(level=[0])\
        .cumsum()        
df_balance
Out[4]:
value quantity
account.fullname transaction.post_date
Assets:Current Assets:Checking Account 2013-06-01 00:00:00+02:00 -30 -30
2014-01-01 00:00:00+01:00 -100 -100
2014-02-03 00:00:00+01:00 -170 -170
2014-03-03 00:00:00+01:00 -240 -240
2014-04-01 00:00:00+02:00 -310 -310
2014-05-01 00:00:00+02:00 -380 -380
2014-05-30 00:00:00+02:00 -410 -410
2014-06-02 00:00:00+02:00 -480 -480
2014-07-01 00:00:00+02:00 -550 -550
2014-08-01 00:00:00+02:00 -620 -620
2014-09-01 00:00:00+02:00 -690 -690
2014-10-01 00:00:00+02:00 -760 -760
2014-11-03 00:00:00+01:00 -830 -830
2014-12-01 00:00:00+01:00 -900 -900
2015-01-01 00:00:00+01:00 -970 -970
2015-01-03 00:00:00+01:00 30 30
2015-02-02 00:00:00+01:00 -40 -40
2015-03-02 00:00:00+01:00 -110 -110
2015-04-01 00:00:00+02:00 -180 -180
2015-05-01 00:00:00+02:00 -250 -250
2015-06-01 00:00:00+02:00 -350 -350
2015-07-01 00:00:00+02:00 -420 -420
2015-08-03 00:00:00+02:00 -490 -490
2015-09-01 00:00:00+02:00 -560 -560
2015-10-01 00:00:00+02:00 -630 -630
2015-11-02 00:00:00+01:00 -700 -700
2015-11-18 00:00:00+01:00 -600 -600
Assets:Current Assets:us account 2015-11-18 00:00:00+01:00 -100 -106.32
Equity:Opening Balances 2015-01-03 00:00:00+01:00 -1000 -1000
Expenses:Insurance:Auto Insurance 2013-06-01 00:00:00+02:00 30 30
... ... ... ...
Expenses:Utilities:Electric 2015-06-01 00:00:00+02:00 540 540
2015-07-01 00:00:00+02:00 570 570
2015-08-03 00:00:00+02:00 600 600
2015-09-01 00:00:00+02:00 630 630
2015-10-01 00:00:00+02:00 660 660
2015-11-02 00:00:00+01:00 690 690
Expenses:Utilities:Gas 2014-01-01 00:00:00+01:00 40 40
2014-02-03 00:00:00+01:00 80 80
2014-03-03 00:00:00+01:00 120 120
2014-04-01 00:00:00+02:00 160 160
2014-05-01 00:00:00+02:00 200 200
2014-06-02 00:00:00+02:00 240 240
2014-07-01 00:00:00+02:00 280 280
2014-08-01 00:00:00+02:00 320 320
2014-09-01 00:00:00+02:00 360 360
2014-10-01 00:00:00+02:00 400 400
2014-11-03 00:00:00+01:00 440 440
2014-12-01 00:00:00+01:00 480 480
2015-01-01 00:00:00+01:00 520 520
2015-02-02 00:00:00+01:00 560 560
2015-03-02 00:00:00+01:00 600 600
2015-04-01 00:00:00+02:00 640 640
2015-05-01 00:00:00+02:00 680 680
2015-06-01 00:00:00+02:00 720 720
2015-07-01 00:00:00+02:00 760 760
2015-08-03 00:00:00+02:00 800 800
2015-09-01 00:00:00+02:00 840 840
2015-10-01 00:00:00+02:00 880 880
2015-11-02 00:00:00+01:00 920 920
Orphan-EUR 2015-01-03 00:00:00+01:00 0 0

79 rows × 2 columns

In [14]:
# clean the balance to be able to plot it (replace NaNs)
df_balance_cleaned = df_balance["quantity"].unstack().fillna(method="ffill",axis=1).T.fillna(0)
df_balance_cleaned
Out[14]:
account.fullname Assets:Current Assets:Checking Account Assets:Current Assets:us account Equity:Opening Balances Expenses:Insurance:Auto Insurance Expenses:Utilities:Electric Expenses:Utilities:Gas Orphan-EUR
transaction.post_date
2013-06-01 00:00:00+02:00 -30 0 0 30 0 0 0
2014-01-01 00:00:00+01:00 -100 0 0 30 30 40 0
2014-02-03 00:00:00+01:00 -170 0 0 30 60 80 0
2014-03-03 00:00:00+01:00 -240 0 0 30 90 120 0
2014-04-01 00:00:00+02:00 -310 0 0 30 120 160 0
2014-05-01 00:00:00+02:00 -380 0 0 30 150 200 0
2014-05-30 00:00:00+02:00 -410 0 0 60 150 200 0
2014-06-02 00:00:00+02:00 -480 0 0 60 180 240 0
2014-07-01 00:00:00+02:00 -550 0 0 60 210 280 0
2014-08-01 00:00:00+02:00 -620 0 0 60 240 320 0
2014-09-01 00:00:00+02:00 -690 0 0 60 270 360 0
2014-10-01 00:00:00+02:00 -760 0 0 60 300 400 0
2014-11-03 00:00:00+01:00 -830 0 0 60 330 440 0
2014-12-01 00:00:00+01:00 -900 0 0 60 360 480 0
2015-01-01 00:00:00+01:00 -970 0 0 60 390 520 0
2015-01-03 00:00:00+01:00 30 0 -1000 60 390 520 0
2015-02-02 00:00:00+01:00 -40 0 -1000 60 420 560 0
2015-03-02 00:00:00+01:00 -110 0 -1000 60 450 600 0
2015-04-01 00:00:00+02:00 -180 0 -1000 60 480 640 0
2015-05-01 00:00:00+02:00 -250 0 -1000 60 510 680 0
2015-06-01 00:00:00+02:00 -350 0 -1000 90 540 720 0
2015-07-01 00:00:00+02:00 -420 0 -1000 90 570 760 0
2015-08-03 00:00:00+02:00 -490 0 -1000 90 600 800 0
2015-09-01 00:00:00+02:00 -560 0 -1000 90 630 840 0
2015-10-01 00:00:00+02:00 -630 0 -1000 90 660 880 0
2015-11-02 00:00:00+01:00 -700 0 -1000 90 690 920 0
2015-11-18 00:00:00+01:00 -600 -106.32 -1000 90 690 920 0
In [15]:
import plotly
import plotly.graph_objs as go

accounts = df_balance.index.get_level_values("account.fullname").unique()

# plot the running balances with plot.ly (open source as of 17/11/2015)
plotly.offline.init_notebook_mode() 
plotly.offline.iplot({
    "data": [
            go.Scatter(
                x=df_balance_cleaned.index,
                y=df_balance_cleaned[acc].astype('float'),
                name=acc,
            ) 
            for acc in accounts
            ],
    "layout": {
        "title": "Running balance for accounts"
    }
})
Drawing...
In [ ]:
 
In [11]:
df_balance_cleaned["Assets:Current Assets:us account"]
Out[11]:
transaction.post_date
2013-06-01 00:00:00+02:00          0
2014-01-01 00:00:00+01:00          0
2014-02-03 00:00:00+01:00          0
2014-03-03 00:00:00+01:00          0
2014-04-01 00:00:00+02:00          0
2014-05-01 00:00:00+02:00          0
2014-05-30 00:00:00+02:00          0
2014-06-02 00:00:00+02:00          0
2014-07-01 00:00:00+02:00          0
2014-08-01 00:00:00+02:00          0
2014-09-01 00:00:00+02:00          0
2014-10-01 00:00:00+02:00          0
2014-11-03 00:00:00+01:00          0
2014-12-01 00:00:00+01:00          0
2015-01-01 00:00:00+01:00          0
2015-01-03 00:00:00+01:00          0
2015-02-02 00:00:00+01:00          0
2015-03-02 00:00:00+01:00          0
2015-04-01 00:00:00+02:00          0
2015-05-01 00:00:00+02:00          0
2015-06-01 00:00:00+02:00          0
2015-07-01 00:00:00+02:00          0
2015-08-03 00:00:00+02:00          0
2015-09-01 00:00:00+02:00          0
2015-10-01 00:00:00+02:00          0
2015-11-02 00:00:00+01:00          0
2015-11-18 00:00:00+01:00    -106.32
Name: Assets:Current Assets:us account, dtype: object
In [ ]: